﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ProjectPerformanceDataSet" targetNamespace="http://tempuri.org/ProjectPerformanceDataSet.xsd" xmlns:mstns="http://tempuri.org/ProjectPerformanceDataSet.xsd" xmlns="http://tempuri.org/ProjectPerformanceDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FactoryConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectPerformanceTableAdapter" GeneratorDataComponentClassName="ProjectPerformanceTableAdapter" Name="ProjectPerformance" UserDataComponentName="ProjectPerformanceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectPerformance" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ProjectUId, ProjectNumber, ProjectName, ClientName, Status, Category, Plataform, Model, CreateDate, StartDate, EndDate, ApprovalDate, EstimatedStartDate, EstimatedEndDate, ProjectDocBase, PaymentProjectUId, ProjectOwner, Description, HourBankMode, Baseline, AccessMode, IsSuspended, TotalSize, PctBudgetBurned, TotalSaleValue, PctIncome, IncomeRank, SiteRank, PctBugEffort, HoursAhead, Velocity, PctWalked FROM factory.ProjectPerformance</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
              <Mapping SourceColumn="ProjectNumber" DataSetColumn="ProjectNumber" />
              <Mapping SourceColumn="ProjectName" DataSetColumn="ProjectName" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Category" DataSetColumn="Category" />
              <Mapping SourceColumn="Plataform" DataSetColumn="Plataform" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="ApprovalDate" DataSetColumn="ApprovalDate" />
              <Mapping SourceColumn="EstimatedStartDate" DataSetColumn="EstimatedStartDate" />
              <Mapping SourceColumn="EstimatedEndDate" DataSetColumn="EstimatedEndDate" />
              <Mapping SourceColumn="ProjectDocBase" DataSetColumn="ProjectDocBase" />
              <Mapping SourceColumn="PaymentProjectUId" DataSetColumn="PaymentProjectUId" />
              <Mapping SourceColumn="ProjectOwner" DataSetColumn="ProjectOwner" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="HourBankMode" DataSetColumn="HourBankMode" />
              <Mapping SourceColumn="Baseline" DataSetColumn="Baseline" />
              <Mapping SourceColumn="AccessMode" DataSetColumn="AccessMode" />
              <Mapping SourceColumn="IsSuspended" DataSetColumn="IsSuspended" />
              <Mapping SourceColumn="TotalSize" DataSetColumn="TotalSize" />
              <Mapping SourceColumn="PctBudgetBurned" DataSetColumn="PctBudgetBurned" />
              <Mapping SourceColumn="TotalSaleValue" DataSetColumn="TotalSaleValue" />
              <Mapping SourceColumn="PctIncome" DataSetColumn="PctIncome" />
              <Mapping SourceColumn="IncomeRank" DataSetColumn="IncomeRank" />
              <Mapping SourceColumn="SiteRank" DataSetColumn="SiteRank" />
              <Mapping SourceColumn="PctBugEffort" DataSetColumn="PctBugEffort" />
              <Mapping SourceColumn="HoursAhead" DataSetColumn="HoursAhead" />
              <Mapping SourceColumn="Velocity" DataSetColumn="Velocity" />
              <Mapping SourceColumn="PctWalked" DataSetColumn="PctWalked" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectPerformance" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUId" GeneratorSourceName="FillByProjectUId" GetMethodModifier="Public" GetMethodName="GetDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUId" UserSourceName="FillByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ProjectUId, ProjectNumber, ProjectName, ClientName, Status, Category, Plataform, Model, CreateDate, StartDate, EndDate, ApprovalDate, EstimatedStartDate, EstimatedEndDate, ProjectDocBase, PaymentProjectUId, ProjectOwner, Description, HourBankMode, Baseline, AccessMode, IsSuspended, TotalSize, PctBudgetBurned, TotalSaleValue, PctIncome, IncomeRank, SiteRank, PctBugEffort, HoursAhead, Velocity, PctWalked FROM factory.ProjectPerformance WHERE ProjectUId = @ProjectUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory.factory.ProjectPerformance" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectPerformance" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByYear" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByYear" GeneratorSourceName="FillByYear" GetMethodModifier="Public" GetMethodName="GetDataByYear" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByYear" UserSourceName="FillByYear">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessMode, ApprovalDate, Baseline, Category, ClientName, CreateDate, Description, EndDate, EstimatedEndDate, EstimatedStartDate, HourBankMode, HoursAhead, IncomeRank, IsSuspended, Model, PaymentProjectUId, PctBudgetBurned, PctBugEffort, PctIncome, Plataform, ProjectDocBase, ProjectName, ProjectNumber, ProjectOwner, ProjectUId, SiteRank, StartDate, Status, TotalSaleValue, TotalSize, Velocity, pctWalked FROM factory.ProjectPerformance WHERE (YEAR(ISNULL(EndDate, GETDATE())) = @Year)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Year" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectPerformance" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByYearAndMember" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByYearAndMember" GeneratorSourceName="FillByYearAndMember" GetMethodModifier="Public" GetMethodName="GetDataByYearAndMember" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByYearAndMember" UserSourceName="FillByYearAndMember">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AccessMode, ApprovalDate, Baseline, Category, ClientName, CreateDate, Description, EndDate, EstimatedEndDate, EstimatedStartDate, HourBankMode, HoursAhead, IncomeRank, IsSuspended, Model, PaymentProjectUId, PctBudgetBurned, PctBugEffort, PctIncome, Plataform, ProjectDocBase, ProjectName, ProjectNumber, ProjectOwner, ProjectUId, SiteRank, StartDate, Status, TotalSaleValue, TotalSize, Velocity, pctWalked FROM factory.ProjectPerformance AS pe WHERE (YEAR(ISNULL(StartDate, GETDATE())) = @Year) AND EXISTS (SELECT 1 AS Expr1 FROM factory.ProjectRole AS pr WHERE (ProjectUId = pe.ProjectUId) AND (ContactId = @Member))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Year" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Member" ColumnName="" DataSourceName="" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@Member" Precision="0" Scale="0" Size="255" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectRoleTableAdapter" GeneratorDataComponentClassName="ProjectRoleTableAdapter" Name="ProjectRole" UserDataComponentName="ProjectRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [factory].[ProjectRole] WHERE (([ProjectRoleUId] = @Original_ProjectRoleUId) AND ([UnitName] = @Original_UnitName) AND ([ContactId] = @Original_ContactId) AND ((@IsNull_ContactEmail = 1 AND [ContactEmail] IS NULL) OR ([ContactEmail] = @Original_ContactEmail)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ([ProjectUId] = @Original_ProjectUId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectRoleUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectRoleUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [factory].[ProjectRole] ([ProjectRoleUId], [UnitName], [ContactId], [ContactEmail], [ContactName], [ProjectUId]) VALUES (@ProjectRoleUId, @UnitName, @ContactId, @ContactEmail, @ContactName, @ProjectUId);
SELECT ProjectRoleUId, UnitName, ContactId, ContactEmail, ContactName, ProjectUId FROM factory.ProjectRole WHERE (ProjectRoleUId = @ProjectRoleUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectRoleUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectRoleUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProjectRoleUId, UnitName, ContactId, ContactEmail, ContactName, ProjectUId FROM factory.ProjectRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [factory].[ProjectRole] SET [ProjectRoleUId] = @ProjectRoleUId, [UnitName] = @UnitName, [ContactId] = @ContactId, [ContactEmail] = @ContactEmail, [ContactName] = @ContactName, [ProjectUId] = @ProjectUId WHERE (([ProjectRoleUId] = @Original_ProjectRoleUId) AND ([UnitName] = @Original_UnitName) AND ([ContactId] = @Original_ContactId) AND ((@IsNull_ContactEmail = 1 AND [ContactEmail] IS NULL) OR ([ContactEmail] = @Original_ContactEmail)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ([ProjectUId] = @Original_ProjectUId));
SELECT ProjectRoleUId, UnitName, ContactId, ContactEmail, ContactName, ProjectUId FROM factory.ProjectRole WHERE (ProjectRoleUId = @ProjectRoleUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectRoleUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectRoleUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectRoleUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectRoleUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProjectRoleUId" DataSetColumn="ProjectRoleUId" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="ContactId" DataSetColumn="ContactId" />
              <Mapping SourceColumn="ContactEmail" DataSetColumn="ContactEmail" />
              <Mapping SourceColumn="ContactName" DataSetColumn="ContactName" />
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.ProjectRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByYear" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByYear" GeneratorSourceName="FillByYear" GetMethodModifier="Public" GetMethodName="GetDataByYear" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByYear" UserSourceName="FillByYear">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ProjectRoleUId, UnitName, ContactId, ContactEmail, ContactName, pr.ProjectUId FROM factory.ProjectRole pr inner join factory.Project p on p.ProjectUId = pr.ProjectUId and YEAR(p.StartDate) = @Year</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Year" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ProjectPerformanceDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ProjectPerformanceDataSet" msprop:Generator_DataSetName="ProjectPerformanceDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ProjectPerformance" msprop:Generator_UserTableName="ProjectPerformance" msprop:Generator_RowDeletedName="ProjectPerformanceRowDeleted" msprop:Generator_RowChangedName="ProjectPerformanceRowChanged" msprop:Generator_RowClassName="ProjectPerformanceRow" msprop:Generator_RowChangingName="ProjectPerformanceRowChanging" msprop:Generator_RowEvArgName="ProjectPerformanceRowChangeEvent" msprop:Generator_RowEvHandlerName="ProjectPerformanceRowChangeEventHandler" msprop:Generator_TableClassName="ProjectPerformanceDataTable" msprop:Generator_TableVarName="tableProjectPerformance" msprop:Generator_RowDeletingName="ProjectPerformanceRowDeleting" msprop:Generator_TablePropName="ProjectPerformance">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectNumber" msprop:Generator_UserColumnName="ProjectNumber" msprop:Generator_ColumnPropNameInRow="ProjectNumber" msprop:Generator_ColumnVarNameInTable="columnProjectNumber" msprop:Generator_ColumnPropNameInTable="ProjectNumberColumn" type="xs:int" />
              <xs:element name="ProjectName" msprop:Generator_UserColumnName="ProjectName" msprop:Generator_ColumnPropNameInRow="ProjectName" msprop:Generator_ColumnVarNameInTable="columnProjectName" msprop:Generator_ColumnPropNameInTable="ProjectNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientName" msprop:Generator_UserColumnName="ClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:short" />
              <xs:element name="Category" msprop:Generator_UserColumnName="Category" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInTable="CategoryColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Plataform" msprop:Generator_UserColumnName="Plataform" msprop:Generator_ColumnPropNameInRow="Plataform" msprop:Generator_ColumnVarNameInTable="columnPlataform" msprop:Generator_ColumnPropNameInTable="PlataformColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_UserColumnName="Model" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInTable="ModelColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" />
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ApprovalDate" msprop:Generator_UserColumnName="ApprovalDate" msprop:Generator_ColumnPropNameInRow="ApprovalDate" msprop:Generator_ColumnVarNameInTable="columnApprovalDate" msprop:Generator_ColumnPropNameInTable="ApprovalDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstimatedStartDate" msprop:Generator_UserColumnName="EstimatedStartDate" msprop:Generator_ColumnPropNameInRow="EstimatedStartDate" msprop:Generator_ColumnVarNameInTable="columnEstimatedStartDate" msprop:Generator_ColumnPropNameInTable="EstimatedStartDateColumn" type="xs:dateTime" />
              <xs:element name="EstimatedEndDate" msprop:Generator_UserColumnName="EstimatedEndDate" msprop:Generator_ColumnPropNameInRow="EstimatedEndDate" msprop:Generator_ColumnVarNameInTable="columnEstimatedEndDate" msprop:Generator_ColumnPropNameInTable="EstimatedEndDateColumn" type="xs:dateTime" />
              <xs:element name="ProjectDocBase" msprop:Generator_UserColumnName="ProjectDocBase" msprop:Generator_ColumnPropNameInRow="ProjectDocBase" msprop:Generator_ColumnVarNameInTable="columnProjectDocBase" msprop:Generator_ColumnPropNameInTable="ProjectDocBaseColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaymentProjectUId" msprop:Generator_UserColumnName="PaymentProjectUId" msprop:Generator_ColumnPropNameInRow="PaymentProjectUId" msprop:Generator_ColumnVarNameInTable="columnPaymentProjectUId" msprop:Generator_ColumnPropNameInTable="PaymentProjectUIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectOwner" msprop:Generator_UserColumnName="ProjectOwner" msprop:Generator_ColumnPropNameInRow="ProjectOwner" msprop:Generator_ColumnVarNameInTable="columnProjectOwner" msprop:Generator_ColumnPropNameInTable="ProjectOwnerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HourBankMode" msprop:Generator_UserColumnName="HourBankMode" msprop:Generator_ColumnPropNameInRow="HourBankMode" msprop:Generator_ColumnVarNameInTable="columnHourBankMode" msprop:Generator_ColumnPropNameInTable="HourBankModeColumn" type="xs:short" />
              <xs:element name="Baseline" msprop:Generator_UserColumnName="Baseline" msprop:Generator_ColumnPropNameInRow="Baseline" msprop:Generator_ColumnVarNameInTable="columnBaseline" msprop:Generator_ColumnPropNameInTable="BaselineColumn" type="xs:int" />
              <xs:element name="AccessMode" msprop:Generator_UserColumnName="AccessMode" msprop:Generator_ColumnPropNameInRow="AccessMode" msprop:Generator_ColumnVarNameInTable="columnAccessMode" msprop:Generator_ColumnPropNameInTable="AccessModeColumn" type="xs:short" />
              <xs:element name="IsSuspended" msprop:Generator_UserColumnName="IsSuspended" msprop:Generator_ColumnPropNameInRow="IsSuspended" msprop:Generator_ColumnVarNameInTable="columnIsSuspended" msprop:Generator_ColumnPropNameInTable="IsSuspendedColumn" type="xs:boolean" />
              <xs:element name="TotalSize" msprop:Generator_UserColumnName="TotalSize" msprop:Generator_ColumnPropNameInRow="TotalSize" msprop:Generator_ColumnVarNameInTable="columnTotalSize" msprop:Generator_ColumnPropNameInTable="TotalSizeColumn" type="xs:long" minOccurs="0" />
              <xs:element name="PctBudgetBurned" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PctBudgetBurned" msprop:Generator_ColumnPropNameInRow="PctBudgetBurned" msprop:Generator_ColumnVarNameInTable="columnPctBudgetBurned" msprop:Generator_ColumnPropNameInTable="PctBudgetBurnedColumn" type="xs:double" minOccurs="0" />
              <xs:element name="TotalSaleValue" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalSaleValue" msprop:Generator_ColumnPropNameInRow="TotalSaleValue" msprop:Generator_ColumnVarNameInTable="columnTotalSaleValue" msprop:Generator_ColumnPropNameInTable="TotalSaleValueColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PctIncome" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PctIncome" msprop:Generator_ColumnPropNameInRow="PctIncome" msprop:Generator_ColumnVarNameInTable="columnPctIncome" msprop:Generator_ColumnPropNameInTable="PctIncomeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="IncomeRank" msdata:ReadOnly="true" msprop:Generator_UserColumnName="IncomeRank" msprop:Generator_ColumnPropNameInRow="IncomeRank" msprop:Generator_ColumnVarNameInTable="columnIncomeRank" msprop:Generator_ColumnPropNameInTable="IncomeRankColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SiteRank" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SiteRank" msprop:Generator_ColumnPropNameInRow="SiteRank" msprop:Generator_ColumnVarNameInTable="columnSiteRank" msprop:Generator_ColumnPropNameInTable="SiteRankColumn" type="xs:long" minOccurs="0" />
              <xs:element name="PctBugEffort" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PctBugEffort" msprop:Generator_ColumnPropNameInRow="PctBugEffort" msprop:Generator_ColumnVarNameInTable="columnPctBugEffort" msprop:Generator_ColumnPropNameInTable="PctBugEffortColumn" type="xs:double" minOccurs="0" />
              <xs:element name="HoursAhead" msdata:ReadOnly="true" msprop:Generator_UserColumnName="HoursAhead" msprop:Generator_ColumnPropNameInRow="HoursAhead" msprop:Generator_ColumnVarNameInTable="columnHoursAhead" msprop:Generator_ColumnPropNameInTable="HoursAheadColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Velocity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Velocity" msprop:Generator_ColumnPropNameInRow="Velocity" msprop:Generator_ColumnVarNameInTable="columnVelocity" msprop:Generator_ColumnPropNameInTable="VelocityColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PctWalked" msdata:ReadOnly="true" msprop:Generator_UserColumnName="PctWalked" msprop:Generator_ColumnPropNameInRow="PctWalked" msprop:Generator_ColumnVarNameInTable="columnPctWalked" msprop:Generator_ColumnPropNameInTable="PctWalkedColumn" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProjectRole" msprop:Generator_UserTableName="ProjectRole" msprop:Generator_RowDeletedName="ProjectRoleRowDeleted" msprop:Generator_RowChangedName="ProjectRoleRowChanged" msprop:Generator_RowClassName="ProjectRoleRow" msprop:Generator_RowChangingName="ProjectRoleRowChanging" msprop:Generator_RowEvArgName="ProjectRoleRowChangeEvent" msprop:Generator_RowEvHandlerName="ProjectRoleRowChangeEventHandler" msprop:Generator_TableClassName="ProjectRoleDataTable" msprop:Generator_TableVarName="tableProjectRole" msprop:Generator_RowDeletingName="ProjectRoleRowDeleting" msprop:Generator_TablePropName="ProjectRole">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProjectRoleUId" msprop:Generator_UserColumnName="ProjectRoleUId" msprop:Generator_ColumnPropNameInRow="ProjectRoleUId" msprop:Generator_ColumnVarNameInTable="columnProjectRoleUId" msprop:Generator_ColumnPropNameInTable="ProjectRoleUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitName" msprop:Generator_UserColumnName="UnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactId" msprop:Generator_UserColumnName="ContactId" msprop:Generator_ColumnPropNameInRow="ContactId" msprop:Generator_ColumnVarNameInTable="columnContactId" msprop:Generator_ColumnPropNameInTable="ContactIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactEmail" msprop:Generator_UserColumnName="ContactEmail" msprop:Generator_ColumnPropNameInRow="ContactEmail" msprop:Generator_ColumnVarNameInTable="columnContactEmail" msprop:Generator_ColumnPropNameInTable="ContactEmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactName" msprop:Generator_UserColumnName="ContactName" msprop:Generator_ColumnPropNameInRow="ContactName" msprop:Generator_ColumnVarNameInTable="columnContactName" msprop:Generator_ColumnPropNameInTable="ContactNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProjectPerformance" />
      <xs:field xpath="mstns:ProjectUId" />
    </xs:unique>
    <xs:unique name="ProjectRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProjectRole" />
      <xs:field xpath="mstns:ProjectRoleUId" />
    </xs:unique>
  </xs:element>
</xs:schema>